<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-12-26. 17:29:25-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Chargeback']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;background-color:#6198C5;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Asset Utilization by Application and Business Unit</staticValue></dataSource></textItem></contents><style><CSS value="height:36px;padding-left:10px;font-family:Arial;font-size:24px;color:#333333;background-color:#FBFBFB;border-bottom:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Application Detail</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<list horizontalPagination="true" name="List1" refQuery="Application Detail" rowsPerPage="2000">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Business Unit"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Application"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Application"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Host"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Host"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Type"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Type"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Tier"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Tier"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Provisioned (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Provisioned (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total Used (TB)"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Total Used (TB)"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><sortList><sortItem refDataItem="Total Provisioned (TB)" sortOrder="descending"/></sortList></list></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Applications</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Capacity Utilization)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Top 10 Applications" name="Combination Chart7" depth="25">
																																<v2_combinationTypeTooltips/>
																																<v2_legend>
																																	<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
																																<v2_commonAxis>
																																	<v2_ordinalAxis autoTruncation="false" truncationText="..." manualTruncationMaxChars="12">
																																		<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									<CSS value="color:#454545"/></style>
																																								</v2_axisLabels></v2_ordinalAxis>
																																	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Application"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																<v2_topLeftAxis>
																																	<v2_combinationChartTypes>
																																		<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
																																			<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Provisioned (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Used (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																																	</v2_combinationChartTypes>
																																	<v2_axis>
																																		<v2_axisRange>
																																			<v2_automaticRange/>
																																		</v2_axisRange>
																																		<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
																																</v2_topLeftAxis>
																																<style>
																																	<CSS value="width:400px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																<noDataHandler>
																																	<contents>
																																		<block>
																																			<contents>
																																				<textItem>
																																					<dataSource>
																																						<staticValue>No Data Available</staticValue>
																																					</dataSource>
																																					<style>
																																						<CSS value="padding:10px 18px;"/>
																																					</style>
																																				</textItem>
																																			</contents>
																																		</block>
																																	</contents>
																																</noDataHandler>
																																<v2_topRightAxis><v2_axis>
																																		<v2_axisRange>
																																			<v2_automaticRange/>
																																		</v2_axisRange>
																																	</v2_axis>
																																	<v2_combinationChartTypes><v2_bar barShape="box"><v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD" transparency="100"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																																		</v2_bar></v2_combinationChartTypes></v2_topRightAxis></v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Applications</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Total IOpS)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="RepCatalog Top 10 Apps IOPS Trend" name="Combination Chart8">
																																<v2_combinationTypeTooltips/>
																																<v2_legend>
																																	<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition><style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style></v2_legend>
																																<v2_commonAxis>
																																	<v2_ordinalAxis>
																																		<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels></v2_ordinalAxis>
																																	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Full Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="MM/dd"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																<v2_topLeftAxis>
																																	<v2_combinationChartTypes>
																																		<v2_line>
																																			<v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#88B2D3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#9AD7CD"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#EBC4B6"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#D1B3D9"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#B8B8BF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#FDCF9B"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#CCCCFF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#FF9292"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#6699CC"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#EE88EE"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Application"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers><chartNestedNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total IOpS"><chartContents><chartTextItem><dataSource><staticValue/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNestedNodes></chartNode></chartNodes></v2_line>
																																	</v2_combinationChartTypes>
																																	<v2_axis>
																																		<v2_axisRange scale="linear">
																							
																						<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/></v2_axisRange><v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,### IOs"/></dataFormat></style>
																						</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
																																</v2_topLeftAxis>
																																<style>
																																	<CSS value="width:400px;height:200px"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																<noDataHandler>
																																	<contents>
																																		<block>
																																			<contents>
																																				<textItem>
																																					<dataSource>
																																						<staticValue>No Data Available</staticValue>
																																					</dataSource>
																																					<style>
																																						<CSS value="padding:10px 18px;"/>
																																					</style>
																																				</textItem>
																																			</contents>
																																		</block>
																																	</contents>
																																</noDataHandler>
																																</v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Business Units</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Capacity Utilization)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="Top 10 Business Units" name="Combination Chart9" depth="25">
	<v2_combinationTypeTooltips/>
	<v2_legend>
		<style>
																																								<defaultStyles>
																																									<defaultStyle refStyle="lg"/>
																																								</defaultStyles>
																																								<CSS value="color:#454545"/></style><v2_legendPosition>
																																		<v2_legendPreset legendPositionPreset="bottom"/>
																																	</v2_legendPosition></v2_legend>
	<v2_commonAxis>
		<v2_ordinalAxis autoTruncation="false" truncationText="..." manualTruncationMaxChars="12">
			<v2_axisLabels>
																																									<style>
																																										<defaultStyles>
																																											<defaultStyle refStyle="al"/>
																																										</defaultStyles>
																																									<CSS value="color:#454545"/></style>
																																								</v2_axisLabels></v2_ordinalAxis>
		<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Business Unit"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
	<v2_topLeftAxis>
		<v2_combinationChartTypes>
			<v2_bar borderColor="white" setOrdinalWidthScale="80" bevel="none" barShape="box">
				<v2_solidPalette>
																																				<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Provisioned (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total Used (TB)"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
		</v2_combinationChartTypes>
		<v2_axis>
			<v2_axisRange>
				<v2_automaticRange/>
			</v2_axisRange>
			<v2_axisLabels>
																																			<style>
																																				<defaultStyles>
																																					<defaultStyle refStyle="al"/>
																																				</defaultStyles>
																																				<CSS value="color:#454545"/><dataFormat><numberFormat pattern="###,### TB"/></dataFormat></style>
																																		</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
	</v2_topLeftAxis>
	<style>
		<CSS value="width:400px;height:200px;color:#454545"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
	<noDataHandler>
		<contents>
			<block>
				<contents>
					<textItem>
						<dataSource>
							<staticValue>No Data Available</staticValue>
						</dataSource>
						<style>
							<CSS value="padding:10px 18px;"/>
						</style>
					</textItem>
				</contents>
			</block>
		</contents>
	</noDataHandler>
	<v2_topRightAxis><v2_axis>
			<v2_axisRange>
				<v2_automaticRange/>
			</v2_axisRange>
		</v2_axis>
		<v2_combinationChartTypes><v2_bar barShape="box"><v2_solidPalette>
					<v2_solidPaletteEntries><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#9AD7CD" transparency="100"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#FDCF9B"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor transparency="0" color="#88B2D3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#EBC4B6"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#B8B8BF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#D1B3D9"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#FFB2C1"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry><v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
				</v2_bar></v2_combinationChartTypes></v2_topRightAxis></v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Business Units</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Total IOpS)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="RepCatalog Top 10 BU IOPS Trend" name="Combination Chart10">
																																<v2_combinationTypeTooltips/>
																																<v2_legend>
																																	<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition><style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style></v2_legend>
																																<v2_commonAxis>
																																	<v2_ordinalAxis>
																																		<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels></v2_ordinalAxis>
																																	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Full Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="MM/dd"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																<v2_topLeftAxis>
																																	<v2_combinationChartTypes>
																																		<v2_line>
																																			<v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#88B2D3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#9AD7CD"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#EBC4B6"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#D1B3D9"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#B8B8BF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#FDCF9B"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#CCCCFF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#FF9292"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#6699CC"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#EE88EE"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Business Unit"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers><chartNestedNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total IOpS"><chartContents><chartTextItem><dataSource><staticValue/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNestedNodes></chartNode></chartNodes></v2_line>
																																	</v2_combinationChartTypes>
																																	<v2_axis>
																																		<v2_axisRange scale="linear">
																							
																						<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/></v2_axisRange><v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###,### IOs"/></dataFormat></style>
																						</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
																																</v2_topLeftAxis>
																																<style>
																																	<CSS value="width:400px;height:200px"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																<noDataHandler>
																																	<contents>
																																		<block>
																																			<contents>
																																				<textItem>
																																					<dataSource>
																																						<staticValue>No Data Available</staticValue>
																																					</dataSource>
																																					<style>
																																						<CSS value="padding:10px 18px;"/>
																																					</style>
																																				</textItem>
																																			</contents>
																																		</block>
																																	</contents>
																																</noDataHandler>
																																</v2_combinationChart>
																														</contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:5px;padding-top:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Business Units</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Latency)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="RepCatalog Top 10 Latency BU Trends" name="Combination Chart11">
																																<v2_combinationTypeTooltips/>
																																<v2_legend>
																																	<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition><style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style></v2_legend>
																																<v2_commonAxis>
																																	<v2_ordinalAxis>
																																		<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels></v2_ordinalAxis>
																																	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Full Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="MM/dd"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																<v2_topLeftAxis>
																																	<v2_combinationChartTypes>
																																		<v2_line>
																																			<v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#88B2D3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#9AD7CD"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#EBC4B6"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#D1B3D9"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#B8B8BF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#FDCF9B"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#CCCCFF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#FF9292"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#6699CC"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#EE88EE"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Business Unit"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers><chartNestedNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Response Time (ms)"><chartContents><chartTextItem><dataSource><staticValue/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNestedNodes></chartNode></chartNodes></v2_line>
																																	</v2_combinationChartTypes>
																																	<v2_axis>
																																		<v2_axisRange scale="linear">
																							
																						<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/></v2_axisRange><v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###.## ms"/></dataFormat></style>
																						</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
																																</v2_topLeftAxis>
																																<style>
																																	<CSS value="width:400px;height:200px"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																<noDataHandler>
																																	<contents>
																																		<block>
																																			<contents>
																																				<textItem>
																																					<dataSource>
																																						<staticValue>No Data Available</staticValue>
																																					</dataSource>
																																					<style>
																																						<CSS value="padding:10px 18px;"/>
																																					</style>
																																				</textItem>
																																			</contents>
																																		</block>
																																	</contents>
																																</noDataHandler>
																																</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;background-color:white;border:1px solid #E1E1E2"/></style><tableRows><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents><textItem><dataSource><staticValue>Top Applications</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:normal;color:#808080"/></style></textItem><textItem><dataSource><staticValue>(by Latency)</staticValue></dataSource><style><CSS value="padding-left:10px;font-family:Arial;font-size:12px;font-style:italic;color:#808080"/></style></textItem></contents><style><CSS value="padding-top:10px;padding-left:10px"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell><tableCell><contents>
																														<v2_combinationChart maxHotspots="10000" refQuery="RepCatalog Top 10 Apps Latency Trends" name="Combination Chart12">
																																<v2_combinationTypeTooltips/>
																																<v2_legend>
																																	<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition><style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					<CSS value="font-family:Arial;color:#454545"/></style></v2_legend>
																																<v2_commonAxis>
																																	<v2_ordinalAxis>
																																		<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/></style>
																						</v2_axisLabels></v2_ordinalAxis>
																																	<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Full Date"><chartContents><chartTextItem><dataSource><dataItemValue refDataItem="Full Date"/></dataSource></chartTextItem></chartContents><style><dataFormat><dateFormat pattern="MM/dd"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																																<v2_topLeftAxis>
																																	<v2_combinationChartTypes>
																																		<v2_line>
																																			<v2_linePalette markerBorderColor="white" markerBorders="show" markerSize="8px"><v2_linePaletteEntries><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#8599D3"><v2_solidColor color="#9ABCC3" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#8599D3"><v2_color color="#88B2D3"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#E3AE6C"><v2_solidColor color="#A8E3D7" transparency="30"/></v2_fillEffect></v2_pointPaletteEntry><v2_lineFill defaultColor="#E3AE6C"><v2_color color="#9AD7CD"/></v2_lineFill></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#EBC4B6"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#D1B3D9"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#B8B8BF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#FDCF9B"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#CCCCFF"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#FF9292"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#6699CC"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry><v2_linePaletteEntry lineWeight="2px"><v2_lineFill defaultColor="#198545"><v2_color color="#EE88EE"/></v2_lineFill><v2_pointPaletteEntry markerShape="circle"><v2_fillEffect defaultColor="#198545"><v2_solidColor color="#198545"/></v2_fillEffect></v2_pointPaletteEntry></v2_linePaletteEntry></v2_linePaletteEntries></v2_linePalette><chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Application"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers><chartNestedNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Response Time (ms)"><chartContents><chartTextItem><dataSource><staticValue/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNestedNodes></chartNode></chartNodes></v2_line>
																																	</v2_combinationChartTypes>
																																	<v2_axis>
																																		<v2_axisRange scale="linear">
																							
																						<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/></v2_axisRange><v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="font-family:Arial;color:#454545"/><dataFormat><numberFormat pattern="###.## ms"/></dataFormat></style>
																						</v2_axisLabels><v2_majorGridlines lineColor="#EEEEF0" lineWeight="0"/></v2_axis>
																																</v2_topLeftAxis>
																																<style>
																																	<CSS value="width:400px;height:200px"/><defaultStyles><defaultStyle refStyle="ch"/></defaultStyles></style>
																																<noDataHandler>
																																	<contents>
																																		<block>
																																			<contents>
																																				<textItem>
																																					<dataSource>
																																						<staticValue>No Data Available</staticValue>
																																					</dataSource>
																																					<style>
																																						<CSS value="padding:10px 18px;"/>
																																					</style>
																																				</textItem>
																																			</contents>
																																		</block>
																																	</contents>
																																</noDataHandler>
																																</v2_combinationChart></contents><style><CSS value="height:5px;border-bottom:1px solid #C0C0C0"/></style></tableCell><tableCell><contents><block>
			<contents/>
		<style><CSS value="width:10px"/></style></block></contents><style><CSS value="background-color:white;text-align:center"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell><tableCell><contents>
																		</contents><style><CSS value="text-align:center"/></style></tableCell><tableCell><contents/><style><CSS value="background-color:white"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:5px;padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top;padding-left:5px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="height:10px;background-color:#F7F7F7;padding-right:10px;padding-left:10px;padding-bottom:10px"/></style></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.905Z"/></XMLAttributes><reportName>6.2 Asset Utilization by Application and Business Unit - ETL</reportName><queries><query name="RepCatalog Top 10 Apps IOPS Trend">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL2">
			<sqlText>SELECT
dwh_custom.pool_dimension.storageName as 'Storage Name',
dwh_custom.pool_dimension.storageManufacturer as 'Vendor',
dwh_custom.pool_dimension.storageModel as 'Model',
dwh_custom.pool_dimension.storagePoolName as 'Aggregate',
dwh_custom.pool_dimension.tier as 'Tier',
dwh_custom.pool_dimension.tiercost as 'Tier Cost',
dwh_custom.pool_dimension.allocatedCapGB/1024 as 'Capacity TB',
dwh_custom.pool_dimension.allocatedCapGB/1024 as 'Total Capacity TB',
dwh_custom.pool_dimension.usedCapGB/1024 as 'Total Used TB',
dwh_custom.pool_dimension.poolIopsCapability as 'DiskIOpSCapability',
dwh_custom.pool_dimension.poolIopsCapability as 'Max Supported IOpS',
dwh_custom.pool_perf_fact.application as 'Application',
IF(dwh_custom.pool_perf_fact.businessUnit='N/A', dwh_custom.pool_perf_fact.lob, dwh_custom.pool_perf_fact.businessUnit) as 'Business Unit',
dwh_custom.pool_perf_fact.avgIOpS as 'Total IOpS',
dwh_custom.pool_perf_fact.maxIOpS as 'Max Total IOpS',
dwh_custom.pool_perf_fact.totalthroughput as 'Total Throughput MB/sec',
dwh_custom.pool_perf_fact.totalresponsetime as 'Response Time (ms)',
dwh_custom.pool_perf_fact.fulldate as 'Full Date'

FROM	dwh_custom.pool_dimension
JOIN	dwh_custom.pool_perf_fact
ON	dwh_custom.pool_perf_fact.storagePoolId=dwh_custom.pool_dimension.storagePoolId

WHERE dwh_custom.pool_perf_fact.fullDate &gt;=(SELECT MAX(dwh_custom.pool_perf_fact.fullDate) 
FROM dwh_custom.pool_perf_fact) - INTERVAL 90 DAY


GROUP BY dwh_custom.pool_perf_fact.application, dwh_custom.pool_perf_fact.fulldate </sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Model"/><mdProjectedItem name="Aggregate"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Tier Cost"/><mdProjectedItem name="Capacity TB"/><mdProjectedItem name="Total Capacity TB"/><mdProjectedItem name="Total Used TB"/><mdProjectedItem name="DiskIOpSCapability"/><mdProjectedItem name="Max Supported IOpS"/><mdProjectedItem name="Application"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Total IOpS"/><mdProjectedItem name="Max Total IOpS"/><mdProjectedItem name="Total Throughput MB/sec"/><mdProjectedItem name="Response Time (ms)"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL2].[Storage Name]</expression></dataItem><dataItem name="Vendor"><expression>[SQL2].[Vendor]</expression></dataItem><dataItem name="Model"><expression>[SQL2].[Model]</expression></dataItem><dataItem name="Aggregate"><expression>[SQL2].[Aggregate]</expression></dataItem><dataItem name="Tier"><expression>[SQL2].[Tier]</expression></dataItem><dataItem name="Tier Cost"><expression>[SQL2].[Tier Cost]</expression></dataItem><dataItem name="Capacity TB"><expression>[SQL2].[Capacity TB]</expression></dataItem><dataItem aggregate="total" name="Total Capacity TB"><expression>[SQL2].[Total Capacity TB]</expression></dataItem><dataItem aggregate="total" name="Total Used TB"><expression>[SQL2].[Total Used TB]</expression></dataItem><dataItem name="DiskIOpSCapability"><expression>[SQL2].[DiskIOpSCapability]</expression></dataItem><dataItem name="Max Supported IOpS"><expression>[SQL2].[Max Supported IOpS]</expression></dataItem><dataItem name="Application"><expression>[SQL2].[Application]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL2].[Business Unit]</expression></dataItem><dataItem aggregate="total" name="Total IOpS"><expression>[SQL2].[Total IOpS]</expression></dataItem><dataItem name="Max Total IOpS"><expression>[SQL2].[Max Total IOpS]</expression></dataItem><dataItem name="Total Throughput MB/sec"><expression>[SQL2].[Total Throughput MB/sec]</expression></dataItem><dataItem name="Response Time (ms)"><expression>[SQL2].[Response Time (ms)]</expression></dataItem><dataItem name="Full Date"><expression>[SQL2].[Full Date]</expression></dataItem><dataItem name="rank"><expression>rank(average([Total IOpS] for [Application]))</expression></dataItem></selection>
		<queryHints><localCache value="false"/></queryHints><detailFilters><detailFilter><filterExpression>[Application]&lt;&gt; 'N/A'</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;6</filterExpression></detailFilter></detailFilters></query><query name="RepCatalog Top 10 BU IOPS Trend">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL2">
			<sqlText>SELECT
dwh_custom.pool_dimension.storageName as 'Storage Name',
dwh_custom.pool_dimension.storageManufacturer as 'Vendor',
dwh_custom.pool_dimension.storageModel as 'Model',
dwh_custom.pool_dimension.storagePoolName as 'Aggregate',
dwh_custom.pool_dimension.tier as 'Tier',
dwh_custom.pool_dimension.tiercost as 'Tier Cost',
dwh_custom.pool_dimension.allocatedCapGB/1024 as 'Capacity TB',
dwh_custom.pool_dimension.allocatedCapGB/1024 as 'Total Capacity TB',
dwh_custom.pool_dimension.usedCapGB/1024 as 'Total Used TB',
dwh_custom.pool_dimension.poolIopsCapability as 'DiskIOpSCapability',
dwh_custom.pool_dimension.poolIopsCapability as 'Max Supported IOpS',
dwh_custom.pool_perf_fact.application as 'Application',
IF(dwh_custom.pool_perf_fact.businessUnit='N/A', dwh_custom.pool_perf_fact.lob, dwh_custom.pool_perf_fact.businessUnit) as 'Business Unit',
dwh_custom.pool_perf_fact.avgIOpS as 'Total IOpS',
dwh_custom.pool_perf_fact.maxIOpS as 'Max Total IOpS',
dwh_custom.pool_perf_fact.totalthroughput as 'Total Throughput MB/sec',
dwh_custom.pool_perf_fact.totalresponsetime as 'Response Time (ms)',
dwh_custom.pool_perf_fact.fulldate as 'Full Date'

FROM	dwh_custom.pool_dimension
JOIN	dwh_custom.pool_perf_fact
ON	dwh_custom.pool_perf_fact.storagePoolId=dwh_custom.pool_dimension.storagePoolId

WHERE dwh_custom.pool_perf_fact.fullDate &gt;=(SELECT MAX(dwh_custom.pool_perf_fact.fullDate) 
FROM dwh_custom.pool_perf_fact) - INTERVAL 90 DAY


GROUP BY IF(dwh_custom.pool_perf_fact.businessUnit='N/A', dwh_custom.pool_perf_fact.lob, dwh_custom.pool_perf_fact.businessUnit), dwh_custom.pool_perf_fact.fulldate </sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Model"/><mdProjectedItem name="Aggregate"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Tier Cost"/><mdProjectedItem name="Capacity TB"/><mdProjectedItem name="Total Capacity TB"/><mdProjectedItem name="Total Used TB"/><mdProjectedItem name="DiskIOpSCapability"/><mdProjectedItem name="Max Supported IOpS"/><mdProjectedItem name="Application"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Total IOpS"/><mdProjectedItem name="Max Total IOpS"/><mdProjectedItem name="Total Throughput MB/sec"/><mdProjectedItem name="Response Time (ms)"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL2].[Storage Name]</expression></dataItem><dataItem name="Vendor"><expression>[SQL2].[Vendor]</expression></dataItem><dataItem name="Model"><expression>[SQL2].[Model]</expression></dataItem><dataItem name="Aggregate"><expression>[SQL2].[Aggregate]</expression></dataItem><dataItem name="Tier"><expression>[SQL2].[Tier]</expression></dataItem><dataItem name="Tier Cost"><expression>[SQL2].[Tier Cost]</expression></dataItem><dataItem name="Capacity TB"><expression>[SQL2].[Capacity TB]</expression></dataItem><dataItem aggregate="total" name="Total Capacity TB"><expression>[SQL2].[Total Capacity TB]</expression></dataItem><dataItem aggregate="total" name="Total Used TB" sort="descending"><expression>[SQL2].[Total Used TB]</expression></dataItem><dataItem name="DiskIOpSCapability"><expression>[SQL2].[DiskIOpSCapability]</expression></dataItem><dataItem name="Max Supported IOpS"><expression>[SQL2].[Max Supported IOpS]</expression></dataItem><dataItem name="Application"><expression>[SQL2].[Application]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL2].[Business Unit]</expression></dataItem><dataItem aggregate="total" name="Total IOpS"><expression>[SQL2].[Total IOpS]</expression></dataItem><dataItem name="Max Total IOpS"><expression>[SQL2].[Max Total IOpS]</expression></dataItem><dataItem name="Total Throughput MB/sec"><expression>[SQL2].[Total Throughput MB/sec]</expression></dataItem><dataItem name="Response Time (ms)"><expression>[SQL2].[Response Time (ms)]</expression></dataItem><dataItem name="Full Date"><expression>[SQL2].[Full Date]</expression></dataItem><dataItem name="rank"><expression>rank(average([Total IOpS] for [Business Unit]))</expression></dataItem></selection>
		<queryHints><localCache value="false"/></queryHints><detailFilters><detailFilter><filterExpression>[Business Unit]&lt;&gt; 'N/A'</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;6</filterExpression></detailFilter></detailFilters></query><query name="RepCatalog Top 10 Latency BU Trends">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL2">
			<sqlText>SELECT
dwh_custom.pool_dimension.storageName as 'Storage Name',
dwh_custom.pool_dimension.storageManufacturer as 'Vendor',
dwh_custom.pool_dimension.storageModel as 'Model',
dwh_custom.pool_dimension.storagePoolName as 'Aggregate',
dwh_custom.pool_dimension.tier as 'Tier',
dwh_custom.pool_dimension.tiercost as 'Tier Cost',
dwh_custom.pool_dimension.allocatedCapGB/1024 as 'Capacity TB',
dwh_custom.pool_dimension.allocatedCapGB/1024 as 'Total Capacity TB',
dwh_custom.pool_dimension.usedCapGB/1024 as 'Total Used TB',
dwh_custom.pool_dimension.poolIopsCapability as 'DiskIOpSCapability',
dwh_custom.pool_dimension.poolIopsCapability as 'Max Supported IOpS',
dwh_custom.pool_perf_fact.application as 'Application',
IF(dwh_custom.pool_perf_fact.businessUnit='N/A', dwh_custom.pool_perf_fact.lob, dwh_custom.pool_perf_fact.businessUnit) as 'Business Unit',
dwh_custom.pool_perf_fact.avgIOpS as 'Total IOpS',
dwh_custom.pool_perf_fact.maxIOpS as 'Max Total IOpS',
dwh_custom.pool_perf_fact.totalthroughput as 'Total Throughput MB/sec',
dwh_custom.pool_perf_fact.totalresponsetime as 'Response Time (ms)',
dwh_custom.pool_perf_fact.fulldate as 'Full Date'

FROM	dwh_custom.pool_dimension
JOIN	dwh_custom.pool_perf_fact
ON	dwh_custom.pool_perf_fact.storagePoolId=dwh_custom.pool_dimension.storagePoolId

WHERE dwh_custom.pool_perf_fact.fullDate &gt;=(SELECT MAX(dwh_custom.pool_perf_fact.fullDate) 
FROM dwh_custom.pool_perf_fact) - INTERVAL 90 DAY


GROUP BY IF(dwh_custom.pool_perf_fact.businessUnit='N/A', dwh_custom.pool_perf_fact.lob, dwh_custom.pool_perf_fact.businessUnit), dwh_custom.pool_perf_fact.fulldate </sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Model"/><mdProjectedItem name="Aggregate"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Tier Cost"/><mdProjectedItem name="Capacity TB"/><mdProjectedItem name="Total Capacity TB"/><mdProjectedItem name="Total Used TB"/><mdProjectedItem name="DiskIOpSCapability"/><mdProjectedItem name="Max Supported IOpS"/><mdProjectedItem name="Application"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Total IOpS"/><mdProjectedItem name="Max Total IOpS"/><mdProjectedItem name="Total Throughput MB/sec"/><mdProjectedItem name="Response Time (ms)"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL2].[Storage Name]</expression></dataItem><dataItem name="Vendor"><expression>[SQL2].[Vendor]</expression></dataItem><dataItem name="Model"><expression>[SQL2].[Model]</expression></dataItem><dataItem name="Aggregate"><expression>[SQL2].[Aggregate]</expression></dataItem><dataItem name="Tier"><expression>[SQL2].[Tier]</expression></dataItem><dataItem name="Tier Cost"><expression>[SQL2].[Tier Cost]</expression></dataItem><dataItem name="Capacity TB"><expression>[SQL2].[Capacity TB]</expression></dataItem><dataItem aggregate="total" name="Total Capacity TB"><expression>[SQL2].[Total Capacity TB]</expression></dataItem><dataItem aggregate="total" name="Total Used TB" sort="descending"><expression>[SQL2].[Total Used TB]</expression></dataItem><dataItem name="DiskIOpSCapability"><expression>[SQL2].[DiskIOpSCapability]</expression></dataItem><dataItem name="Max Supported IOpS"><expression>[SQL2].[Max Supported IOpS]</expression></dataItem><dataItem name="Application"><expression>[SQL2].[Application]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL2].[Business Unit]</expression></dataItem><dataItem aggregate="total" name="Total IOpS"><expression>[SQL2].[Total IOpS]</expression></dataItem><dataItem name="Max Total IOpS"><expression>[SQL2].[Max Total IOpS]</expression></dataItem><dataItem name="Total Throughput MB/sec"><expression>[SQL2].[Total Throughput MB/sec]</expression></dataItem><dataItem aggregate="average" name="Response Time (ms)"><expression>[SQL2].[Response Time (ms)]</expression></dataItem><dataItem name="Full Date"><expression>[SQL2].[Full Date]</expression></dataItem><dataItem name="rank"><expression>rank(average([Response Time (ms)] for [Business Unit]))</expression></dataItem></selection>
		<queryHints><localCache value="false"/></queryHints><detailFilters><detailFilter><filterExpression>[Business Unit]&lt;&gt; 'N/A'</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;6</filterExpression></detailFilter></detailFilters></query><query name="RepCatalog Top 10 Apps Latency Trends">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL2">
			<sqlText>SELECT
dwh_custom.pool_dimension.storageName as 'Storage Name',
dwh_custom.pool_dimension.storageManufacturer as 'Vendor',
dwh_custom.pool_dimension.storageModel as 'Model',
dwh_custom.pool_dimension.storagePoolName as 'Aggregate',
dwh_custom.pool_dimension.tier as 'Tier',
dwh_custom.pool_dimension.tiercost as 'Tier Cost',
dwh_custom.pool_dimension.allocatedCapGB/1024 as 'Capacity TB',
dwh_custom.pool_dimension.allocatedCapGB/1024 as 'Total Capacity TB',
dwh_custom.pool_dimension.usedCapGB/1024 as 'Total Used TB',
dwh_custom.pool_dimension.poolIopsCapability as 'DiskIOpSCapability',
dwh_custom.pool_dimension.poolIopsCapability as 'Max Supported IOpS',
dwh_custom.pool_perf_fact.application as 'Application',
IF(dwh_custom.pool_perf_fact.businessUnit='N/A', dwh_custom.pool_perf_fact.lob, dwh_custom.pool_perf_fact.businessUnit) as 'Business Unit',
dwh_custom.pool_perf_fact.avgIOpS as 'Total IOpS',
dwh_custom.pool_perf_fact.maxIOpS as 'Max Total IOpS',
dwh_custom.pool_perf_fact.totalthroughput as 'Total Throughput MB/sec',
dwh_custom.pool_perf_fact.totalresponsetime as 'Response Time (ms)',
dwh_custom.pool_perf_fact.fulldate as 'Full Date'

FROM	dwh_custom.pool_dimension
JOIN	dwh_custom.pool_perf_fact
ON	dwh_custom.pool_perf_fact.storagePoolId=dwh_custom.pool_dimension.storagePoolId

WHERE dwh_custom.pool_perf_fact.fullDate &gt;=(SELECT MAX(dwh_custom.pool_perf_fact.fullDate) 
FROM dwh_custom.pool_perf_fact) - INTERVAL 90 DAY


GROUP BY dwh_custom.pool_perf_fact.application, dwh_custom.pool_perf_fact.fulldate </sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Vendor"/><mdProjectedItem name="Model"/><mdProjectedItem name="Aggregate"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Tier Cost"/><mdProjectedItem name="Capacity TB"/><mdProjectedItem name="Total Capacity TB"/><mdProjectedItem name="Total Used TB"/><mdProjectedItem name="DiskIOpSCapability"/><mdProjectedItem name="Max Supported IOpS"/><mdProjectedItem name="Application"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Total IOpS"/><mdProjectedItem name="Max Total IOpS"/><mdProjectedItem name="Total Throughput MB/sec"/><mdProjectedItem name="Response Time (ms)"/><mdProjectedItem name="Full Date"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL2].[Storage Name]</expression></dataItem><dataItem name="Vendor"><expression>[SQL2].[Vendor]</expression></dataItem><dataItem name="Model"><expression>[SQL2].[Model]</expression></dataItem><dataItem name="Aggregate"><expression>[SQL2].[Aggregate]</expression></dataItem><dataItem name="Tier"><expression>[SQL2].[Tier]</expression></dataItem><dataItem name="Tier Cost"><expression>[SQL2].[Tier Cost]</expression></dataItem><dataItem name="Capacity TB"><expression>[SQL2].[Capacity TB]</expression></dataItem><dataItem aggregate="total" name="Total Capacity TB"><expression>[SQL2].[Total Capacity TB]</expression></dataItem><dataItem aggregate="total" name="Total Used TB"><expression>[SQL2].[Total Used TB]</expression></dataItem><dataItem name="DiskIOpSCapability"><expression>[SQL2].[DiskIOpSCapability]</expression></dataItem><dataItem name="Max Supported IOpS"><expression>[SQL2].[Max Supported IOpS]</expression></dataItem><dataItem name="Application"><expression>[SQL2].[Application]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL2].[Business Unit]</expression></dataItem><dataItem aggregate="total" name="Total IOpS"><expression>[SQL2].[Total IOpS]</expression></dataItem><dataItem name="Max Total IOpS"><expression>[SQL2].[Max Total IOpS]</expression></dataItem><dataItem name="Total Throughput MB/sec"><expression>[SQL2].[Total Throughput MB/sec]</expression></dataItem><dataItem aggregate="average" name="Response Time (ms)"><expression>[SQL2].[Response Time (ms)]</expression></dataItem><dataItem name="Full Date"><expression>[SQL2].[Full Date]</expression></dataItem><dataItem name="rank"><expression>rank(average([Response Time (ms)] for [Application]))</expression></dataItem></selection>
		<queryHints><localCache value="false"/></queryHints><detailFilters><detailFilter><filterExpression>[Application]&lt;&gt; 'N/A'</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;6</filterExpression></detailFilter></detailFilters></query><query name="All Apps">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL3">
			<sqlText>SELECT
dwh_custom.app_busunit_capacity.storageName as 'Storage Name',
dwh_custom.app_busunit_capacity.allocatedCapTB as 'Total Capacity TB',
dwh_custom.app_busunit_capacity.usedCapTB as 'Total Used TB',
dwh_custom.app_busunit_capacity.tier as 'Tier',
IF(dwh_custom.app_busunit_capacity.busUnit='N/A', dwh_custom.app_busunit_capacity.lob, dwh_custom.app_busunit_capacity.busUnit) as 'Business Unit',
dwh_custom.app_busunit_capacity.application as 'Application'

FROM dwh_custom.app_busunit_capacity

WHERE dwh_custom.app_busunit_capacity.application&lt;&gt; 'N/A'

GROUP BY dwh_custom.app_busunit_capacity.application</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Total Capacity TB"/><mdProjectedItem name="Total Used TB"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Application"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL3].[Storage Name]</expression></dataItem><dataItem name="Total Capacity TB"><expression>[SQL3].[Total Capacity TB]</expression></dataItem><dataItem name="Total Used TB"><expression>[SQL3].[Total Used TB]</expression></dataItem><dataItem name="Tier"><expression>[SQL3].[Tier]</expression></dataItem><dataItem name="Business Unit/LOB"><expression>[SQL3].[Business Unit]</expression></dataItem><dataItem name="Application"><expression>[SQL3].[Application]</expression></dataItem></selection>
		<queryHints><localCache value="false"/></queryHints></query><query name="Top 10 Apps">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL3">
			<sqlText>SELECT
dwh_custom.app_busunit_capacity.storageName as 'Storage Name',
sum(dwh_custom.app_busunit_capacity.allocatedCapTB) as 'Total Capacity TB',
sum(dwh_custom.app_busunit_capacity.usedCapTB) as 'Total Used TB',
dwh_custom.app_busunit_capacity.tier as 'Tier',
IF(dwh_custom.app_busunit_capacity.busUnit='N/A', dwh_custom.app_busunit_capacity.lob, dwh_custom.app_busunit_capacity.busUnit) as 'Business Unit',
dwh_custom.app_busunit_capacity.application as 'Application'

FROM dwh_custom.app_busunit_capacity
WHERE dwh_custom.app_busunit_capacity.application&lt;&gt;'N/A'

GROUP BY dwh_custom.app_busunit_capacity.application

ORDER BY sum(dwh_custom.app_busunit_capacity.allocatedCapTB) DESC LIMIT 10</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Total Capacity TB"/><mdProjectedItem name="Total Used TB"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Application"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL3].[Storage Name]</expression></dataItem><dataItem aggregate="total" name="Total Capacity TB"><expression>[SQL3].[Total Capacity TB]</expression></dataItem><dataItem aggregate="total" name="Total Used TB"><expression>[SQL3].[Total Used TB]</expression></dataItem><dataItem name="Tier"><expression>[SQL3].[Tier]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL3].[Business Unit]</expression></dataItem><dataItem name="Application"><expression>[SQL3].[Application]</expression></dataItem></selection>
		<queryHints><localCache value="false"/></queryHints></query><query name="Top 10 BUs">
			<source>
				
			<sqlQuery dataSource="dwh_inventory" name="SQL3">
			<sqlText>SELECT
dwh_custom.app_busunit_capacity.storageName as 'Storage Name',
sum(dwh_custom.app_busunit_capacity.allocatedCapTB) as 'Total Capacity TB',
sum(dwh_custom.app_busunit_capacity.usedCapTB) as 'Total Used TB',
dwh_custom.app_busunit_capacity.tier as 'Tier',
IF(dwh_custom.app_busunit_capacity.busUnit='N/A', dwh_custom.app_busunit_capacity.lob, dwh_custom.app_busunit_capacity.busUnit) as 'Business Unit',
dwh_custom.app_busunit_capacity.application as 'Application'

FROM dwh_custom.app_busunit_capacity

WHERE dwh_custom.app_busunit_capacity.busUnit&lt;&gt;'N/A'

GROUP BY IF(dwh_custom.app_busunit_capacity.busUnit='N/A', dwh_custom.app_busunit_capacity.lob, dwh_custom.app_busunit_capacity.busUnit)
ORDER BY sum(dwh_custom.app_busunit_capacity.allocatedCapTB) DESC LIMIT 10</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Total Capacity TB"/><mdProjectedItem name="Total Used TB"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Application"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL3].[Storage Name]</expression></dataItem><dataItem aggregate="total" name="Total Capacity TB"><expression>[SQL3].[Total Capacity TB]</expression></dataItem><dataItem aggregate="total" name="Total Used TB"><expression>[SQL3].[Total Used TB]</expression></dataItem><dataItem name="Tier"><expression>[SQL3].[Tier]</expression></dataItem><dataItem name="Business Unit"><expression>[SQL3].[Business Unit]</expression></dataItem><dataItem name="Application"><expression>[SQL3].[Application]</expression></dataItem></selection>
		<queryHints><localCache value="false"/></queryHints></query><query name="Application Detail">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_capacity" type="passThrough">
			<sqlText>SELECT 	
     
        x.BusinessUnit as 'Business Unit',
        x.Application as 'Application',
        x.Host as 'Host',
        x.Type as 'Type',
        x.StorageName as 'Storage Name',
        x.tier as 'Tier',
        x.provTB AS 'Total Provisioned (TB)',
        x.provGB as 'Total Provisioned (GB)',
        x.usedTB as 'Total Used (TB)',
        x.usedGB as 'Total Used (GB)'
	
	
	
FROM 	(
	SELECT 	
	
	        total.Tenant,
	        total.LineofBusiness,
	        total.BusinessUnit,
	        total.Project,
	        total.Application,
	        total.tier,
	        total.StorageName,
	        total.Host as 'Host',
	        total.OS as 'OS',
	        total.Type as 'Type',
	        total.Processors as 'Processors',
	        total.memory as 'Memory',
	        SUM(total.provTB) AS provTB,
	        SUM(total.provGB) as provGB,
	        SUM(total.usedTB) AS usedTB,
	        SUM(total.usedGB) as usedGB,
	        	        
		SUM(total.cost) AS cost
	FROM 	(
		SELECT 	
		
		dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
                dwh_capacity.business_entity_dimension.lob AS 'LineofBusiness',
                dwh_capacity.business_entity_dimension.businessUnit AS 'BusinessUnit',
                dwh_capacity.business_entity_dimension.project AS 'Project',
                dwh_capacity.application_dimension.name AS 'Application',
                dwh_capacity.storage_dimension.name as 'StorageName',
		dwh_capacity.host_dimension.name as 'Host',
		null as 'OS',
		null as 'Processors',
		null as 'Memory',
		
		'Physical' as 'Type',

		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024/1024,2) AS provTB,
			ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) AS provGB,
			ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024/1024,2) AS usedTB,
			ROUND(SUM(dwh_capacity.chargeback_fact.usedCapacityMB)/1024,2) AS usedGB,
			
			
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.chargeback_fact.provisionedCapacityMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.chargeback_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.chargeback_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		AND 	dwh_capacity.chargeback_fact.mappedByVM = 0
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.chargeback_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.chargeback_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		JOIN    dwh_capacity.storage_dimension
		ON      dwh_capacity.storage_dimension.tk=dwh_capacity.chargeback_fact.storagetk
		JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		LEFT JOIN    dwh_capacity.business_entity_dimension
		ON      dwh_capacity.business_entity_dimension.tk=dwh_capacity.chargeback_fact.businessentitytk
		LEFT JOIN    dwh_capacity.application_dimension
		ON           dwh_capacity.application_dimension.tk=dwh_capacity.chargeback_fact.applicationtk
		LEFT JOIN    dwh_capacity.host_dimension
		ON           dwh_capacity.host_dimension.tk=dwh_capacity.chargeback_fact.hosttk
		
		GROUP BY
			Tier, Host,
			dwh_capacity.date_dimension.fullDate
		UNION
		SELECT 	

                dwh_capacity.business_entity_dimension.tenant AS 'Tenant',
                dwh_capacity.business_entity_dimension.lob AS 'LineofBusiness',
                dwh_capacity.business_entity_dimension.businessUnit AS 'BusinessUnit',
                dwh_capacity.business_entity_dimension.project AS 'Project',
                dwh_capacity.application_dimension.name AS 'Application',
                dwh_capacity.storage_dimension.name as 'StorageName',
		dwh_capacity.vm_dimension.name as 'Host',
		dwh_capacity.vm_dimension.os as 'OS',
		(SELECT dwh_inventory.hv_virtual_machine.processors FROM dwh_inventory.hv_virtual_machine 
		WHERE dwh_inventory.hv_virtual_machine.id=dwh_capacity.vm_dimension.id) as 'Processors',
		
		(SELECT dwh_inventory.hv_virtual_machine.memory FROM dwh_inventory.hv_virtual_machine 
		WHERE dwh_inventory.hv_virtual_machine.id=dwh_capacity.vm_dimension.id) as 'Memory',
		
		'Virtual' as 'Type',
		
		CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_capacity.tier_dimension.name
				ELSE 	dwh_capacity.service_level_dimension.name
			END 	AS 	tier,
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	dwh_inventory.tier.cost
				ELSE 	dwh_inventory.service_level.cost
			END 	AS 	tierPerGB,
			dwh_capacity.date_dimension.fullDate AS fullDate,
			ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024/1024,2) AS provTB,
                        ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) AS provGB,
                        ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB)/1024/1024,2) AS usedTB,
                        ROUND(SUM(dwh_capacity.vm_capacity_fact.actualMB)/1024,2) AS usedGB,
                        
                        
			CASE 	WHEN 	dwh_capacity.service_level_dimension.tk = 0
				THEN 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.tier.cost, 2)
				ELSE 	ROUND(ROUND(SUM(dwh_capacity.vm_capacity_fact.provisionedMB)/1024,2) * dwh_inventory.service_level.cost, 2)
			END 	AS 	cost
		FROM 	dwh_capacity.vm_capacity_fact
		JOIN 	dwh_capacity.service_level_dimension
		ON 	dwh_capacity.vm_capacity_fact.serviceLevelTk = dwh_capacity.service_level_dimension.tk
		JOIN    dwh_capacity.storage_dimension
		ON      dwh_capacity.storage_dimension.tk=dwh_capacity.vm_capacity_fact.storagetk
		JOIN 	dwh_capacity.tier_dimension
		ON 	dwh_capacity.vm_capacity_fact.tierTk = dwh_capacity.tier_dimension.tk
		JOIN 	dwh_capacity.date_dimension
		ON 	dwh_capacity.vm_capacity_fact.dateTk = dwh_capacity.date_dimension.tk
		AND 	dwh_capacity.date_dimension.latest = 1
		LEFT JOIN 	dwh_inventory.tier
		ON 	dwh_capacity.tier_dimension.id = dwh_inventory.tier.id
		LEFT JOIN 	dwh_inventory.service_level
		ON 	dwh_capacity.service_level_dimension.id = dwh_inventory.service_level.id
		LEFT JOIN    dwh_capacity.business_entity_dimension
		ON      dwh_capacity.business_entity_dimension.tk=dwh_capacity.vm_capacity_fact.businessentitytk
		LEFT JOIN    dwh_capacity.application_dimension
		ON           dwh_capacity.application_dimension.tk=dwh_capacity.vm_capacity_fact.applicationtk
		LEFT JOIN    dwh_capacity.vm_dimension
		ON           dwh_capacity.vm_dimension.tk=dwh_capacity.vm_capacity_fact.vmtk
		
		GROUP BY
			Tier, Host,
			dwh_capacity.date_dimension.fullDate
		) total
	GROUP BY Host
	
	) X
	
	GROUP BY Host
	</sqlText>
		<mdProjectedItems><mdProjectedItem name="Business Unit"/><mdProjectedItem name="Application"/><mdProjectedItem name="Host"/><mdProjectedItem name="Type"/><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Tier"/><mdProjectedItem name="Total Provisioned (TB)"/><mdProjectedItem name="Total Provisioned (GB)"/><mdProjectedItem name="Total Used (TB)"/><mdProjectedItem name="Total Used (GB)"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Business Unit"><expression>[SQL1].[Business Unit]</expression></dataItem><dataItem name="Application"><expression>[SQL1].[Application]</expression></dataItem><dataItem name="Host"><expression>[SQL1].[Host]</expression></dataItem><dataItem name="Type"><expression>[SQL1].[Type]</expression></dataItem><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Tier"><expression>[SQL1].[Tier]</expression></dataItem><dataItem name="Total Provisioned (TB)"><expression>[SQL1].[Total Provisioned (TB)]</expression></dataItem><dataItem name="Total Provisioned (GB)"><expression>[SQL1].[Total Provisioned (GB)]</expression></dataItem><dataItem name="Total Used (TB)"><expression>[SQL1].[Total Used (TB)]</expression></dataItem><dataItem name="Total Used (GB)"><expression>[SQL1].[Total Used (GB)]</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Host]&lt;&gt;'N/A'</filterExpression></detailFilter></detailFilters></query><query name="Top 10 Applications">
			<source>
				
			<queryRef refQuery="Application Detail"/></source>
			<selection><dataItem name="Application"><expression>[Application Detail].[Application]</expression></dataItem><dataItem name="Total Provisioned (TB)" aggregate="total"><expression>[Application Detail].[Total Provisioned (TB)]</expression></dataItem><dataItem name="Total Used (TB)" aggregate="total"><expression>[Application Detail].[Total Used (TB)]</expression></dataItem><dataItem name="rank"><expression>rank([Total Provisioned (TB)])</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Application]&lt;&gt;'N/A'</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;11</filterExpression></detailFilter></detailFilters></query><query name="Top 10 Business Units">
			<source>
				
			<queryRef refQuery="Application Detail"/></source>
			<selection><dataItem name="Business Unit"><expression>[Application Detail].[Business Unit]</expression></dataItem><dataItem name="Total Provisioned (TB)" aggregate="total"><expression>[Application Detail].[Total Provisioned (TB)]</expression></dataItem><dataItem name="Total Used (TB)" aggregate="total"><expression>[Application Detail].[Total Used (TB)]</expression></dataItem><dataItem name="rank"><expression>rank([Total Provisioned (TB)])</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[Business Unit]&lt;&gt;'N/A'</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>[rank]&lt;11</filterExpression></detailFilter></detailFilters></query></queries></report>